/*
 Navicat Premium Data Transfer

 Source Server         : LocalDB
 Source Server Type    : SQL Server
 Source Server Version : 15004153
 Source Host           : (localdb)\MSSQLLocalDB:1433
 Source Catalog        : OcelotSettings
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 15004153
 File Encoding         : 65001

 Date: 07/07/2023 17:37:53
*/


-- ----------------------------
-- Table structure for UserAccount
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[UserAccount]') AND type IN ('U'))
	DROP TABLE [dbo].[UserAccount]
GO

CREATE TABLE [dbo].[UserAccount] (
  [ID] bigint  NOT NULL,
  [Account] varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [Password] varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [OpenId] varchar(38) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [Enabled] bit  NOT NULL,
  [Name] nvarchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[UserAccount] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键ID',
'SCHEMA', N'dbo',
'TABLE', N'UserAccount',
'COLUMN', N'ID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'账户',
'SCHEMA', N'dbo',
'TABLE', N'UserAccount',
'COLUMN', N'Account'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'UserAccount',
'COLUMN', N'Password'
GO

EXEC sp_addextendedproperty
'MS_Description', N'OpenId',
'SCHEMA', N'dbo',
'TABLE', N'UserAccount',
'COLUMN', N'OpenId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否启动',
'SCHEMA', N'dbo',
'TABLE', N'UserAccount',
'COLUMN', N'Enabled'
GO

EXEC sp_addextendedproperty
'MS_Description', N'姓名',
'SCHEMA', N'dbo',
'TABLE', N'UserAccount',
'COLUMN', N'Name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户表',
'SCHEMA', N'dbo',
'TABLE', N'UserAccount'
GO


-- ----------------------------
-- Records of UserAccount
-- ----------------------------
INSERT INTO [dbo].[UserAccount] ([ID], [Account], [Password], [OpenId], [Enabled], [Name]) VALUES (N'12', N'admin', N'123456', N'', N'1', N'admin')
GO


-- ----------------------------
-- Primary Key structure for table UserAccount
-- ----------------------------
ALTER TABLE [dbo].[UserAccount] ADD CONSTRAINT [PK__UserAcco__3214EC27223F0A4E] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

